package org.example.erp.mapper;

import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import org.apache.ibatis.annotations.Param;
import org.example.erp.domain.Inventory;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.example.erp.domain.ProductMaterialManagement;

import java.util.List;

/**
* @author 86180
* @description 针对表【inventory(库存管理表)】的数据库操作Mapper
* @createDate 2024-11-28 15:28:32
* @Entity org.example.erp.domain.Inventory
*/
public interface InventoryMapper extends BaseMapper<Inventory> {
      IPage<Inventory>findinventory(@Param(value = "page") Page<Inventory> page,
                                    @Param("materialProductCode") String materialProductCode,
                                    @Param("materialProductName")String materialProductName,
                                    @Param("inboundBatchNumber")String inboundBatchNumber,
                                    @Param("warehouseName")String warehouseName,
                                    @Param("supplierCode") String supplierCode,
                                    @Param("supplierName") String supplierName,
                                    @Param("validityPeriodOfInventory") String validityPeriodOfInventory,
                                    @Param("materialIds") List<Integer> materialIds);

      List<Inventory> findInventoryById(String id);
}




